SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001747s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480654 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480654 [ RunTime:0.011176s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (685357,560553,555680,74301,246336,455384,54761,1043041,859100,1044255,633509,669179,975810,105724,1009470,699533,280990,925157,43994,397781,121747,893330,906639,541841,84361,281255,576233,812985,1011191,841703,82917,165718,845830,885809,227566,389497,380523,183943,698282,914042,1013360,494096,594160,135811,954811,316758,442806,655501,906910,118726,604844,103283,638705,790314,916044,268658,147469,37743,798540,970777) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]