SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 654760 LIMIT 1 [ RunTime:0.000581s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 654760 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435620,28978,950279,351764,395025,112694,1013570,116001,508292,305531,670168,197504,1021224,605258,399203,330582,227607,1006562,643640,473744,1043587,871279,1022288,409132,702233,679822,767357,725969,225530,413201,116494,546516,336253,238630,938123,2779,487185,47883,91052,141700,1001566,637120,179295,473595,27124,555016,84217,904828,819489,927421,515489,235420,777802,1020560,389815,835660,495898,327451,1038336,689605) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 654760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 654760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000369s ]