SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540948 LIMIT 1 [ RunTime:0.000830s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540948 [ RunTime:0.001508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (291143,198933,345886,728432,85362,9323,984550,179088,323024,619506,596660,136471,335333,658077,261249,975544,348510,907169,479988,451092,274028,268154,666062,610546,172166,698328,563027,371092,292240,679,3853,15163,952199,811770,747558,359399,864592,342127,644827,1036027,798331,556955,325254,496108,545595,3838,659247,512006,531002,926867,881456,998843,986585,81607,905756,176920,1018311,225490,933365,634421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]