SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413691 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413691 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011076,918684,194146,721880,435247,792520,15962,546032,43382,838544,208670,1042796,352055,323785,382928,663943,451562,112374,79648,476392,823946,120944,378830,702422,207596,442220,934665,58241,1012728,699213,620710,23045,197448,388562,621369,863026,1017955,1025955,1041332,896849,906642,383218,156666,720518,380154,537801,930042,787903,1035473,862881,145712,1007056,282503,409161,533655,863219,178580,844611,616810,531168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001661s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]