SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 987418 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 987418 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (573096,595363,481405,407043,567386,632375,75335,528789,80340,479159,2414,576741,1008512,271144,668312,631845,738024,581248,559162,994467,479656,480283,490197,652494,72775,263988,626339,373051,940209,265262,109623,278612,100232,350106,410156,107814,357039,149465,413202,131054,278920,206421,114716,303002,157588,456089,797152,338187,79634,744345,879346,38427,750654,925592,298842,301090,448842,889645,413594,274484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 987418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 987418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]