SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529844 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529844 [ RunTime:0.002079s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (611747,166139,458302,1016987,408906,549984,523726,195503,831240,870917,283530,814573,977793,405689,193123,580117,354830,733903,1021021,536879,816434,922536,2978,678488,90772,952229,71250,1022681,919089,476446,691734,866532,257772,973921,784190,1017575,972597,716981,446985,238773,581716,684833,793152,46859,360563,745078,954733,85208,792390,450783,937388,190384,1026268,373238,415311,210872,71001,401550,828935,744836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]