SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284498 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284498 [ RunTime:0.002118s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529006,443186,1045024,698822,72212,524365,749247,581372,369496,492100,485029,883102,895254,231261,317225,927568,345566,225155,434037,139141,696501,199915,29554,375438,748490,548217,854792,593090,354714,398193,298611,629006,537110,833590,193554,177384,477064,214991,23349,707282,38812,44626,665821,236170,423044,818365,848714,386603,532303,729508,242116,928961,561310,625541,516410,196020,217058,225089,90926,843927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]