SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542602 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542602 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (858598,251408,11161,858680,762399,362200,509484,931893,471114,992395,1030613,425275,123288,910030,654465,865500,273912,118853,369751,8183,712986,726491,925018,905285,769230,118461,73521,273567,165393,109547,1022555,827140,1014209,989419,22733,527357,289496,402248,1003591,829247,103868,527860,5235,180133,613326,120904,29324,86547,564159,358030,873249,718887,363642,800907,162993,503748,23878,734498,821220,969011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003859s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542602 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542602 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]