SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537091 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537091 [ RunTime:0.001532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391234,640678,764502,559638,1028210,424801,847038,387742,678141,559910,562859,34179,972205,947267,284080,43719,1032412,448555,385832,914957,840074,52654,75495,378560,673493,592666,275190,255604,924459,744687,42950,230149,279693,443378,595577,972379,221152,784270,800376,545057,533180,95589,560311,272787,330378,556033,114648,65167,342490,218282,830638,376696,798922,978454,670469,475615,537437,1043013,269316,240573) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001366s ]