SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434343 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434343 [ RunTime:0.005199s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593128,500431,1009027,539827,513224,776928,751766,1005533,447525,248539,635217,223990,847635,148213,278580,873233,456617,502375,402926,140978,14129,536230,331053,958092,219429,586014,888393,28330,833445,450020,997974,658161,153646,498858,988857,753646,510780,784251,1023057,523359,519300,144678,725528,599113,1020298,920976,278758,465679,639568,596629,408770,48412,382915,82555,457293,535881,208486,34872,1031150,162953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000689s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]