SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001827s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401945 LIMIT 1 [ RunTime:0.000600s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401945 [ RunTime:0.003275s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (671341,981244,763339,873535,45701,64081,140346,810697,649,1040230,174013,706932,293540,461673,317291,892093,1015446,195953,608410,742495,386600,32982,667843,823139,412460,744971,945348,191021,893493,431059,567257,35111,989119,962970,540855,955492,404432,173291,136030,294469,454542,1031032,752061,103836,346863,423642,837063,936386,59902,720918,682846,257107,147162,241584,428577,842645,1048575,1044204,679576,178107) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003803s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401945 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401945 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]