SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001688s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584012 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584012 [ RunTime:0.001468s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319716,213172,551364,543109,413776,520550,898845,621720,226445,932897,849985,262839,50678,466241,962488,228993,398527,456430,889458,994282,360316,143202,1023678,293938,642973,544371,950180,931393,1041972,454732,1046784,750700,572503,463128,599585,692313,1040320,756975,875315,1515,596011,786123,548822,805006,426873,162725,337575,279214,869899,977554,881735,675973,953342,967281,409367,34954,791000,522299,269910,522159) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]