SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001718s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409560 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409560 [ RunTime:0.002147s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (954693,432465,554460,409776,794629,70486,305336,947076,879267,355855,317245,573063,45008,608674,980775,479287,392585,996708,854452,147894,379787,120070,565360,716479,902221,53425,315924,177360,959768,56268,327698,845600,169186,141912,201219,563671,591734,334201,429914,448897,321298,92271,65324,678486,667921,197372,202428,320801,631401,137922,689855,473620,117630,12791,225425,363299,147555,467183,681676,713590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409560 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409560 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]