SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518167 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518167 [ RunTime:0.002256s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114644,483419,882882,85828,199673,706959,325016,255189,327153,284257,1025831,503734,633618,976697,152038,910528,993270,477409,317398,665524,746148,1012757,441480,816746,392644,72841,914652,629678,87612,310146,1029188,364167,43752,267566,738660,631612,8461,420672,1044276,420271,762507,969651,162948,419470,69487,491562,985673,761686,750566,140069,991217,982006,498685,1038245,62588,1015289,811394,632521,581424,143028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518167 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518167 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]