SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394180 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394180 [ RunTime:0.002804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029330,57886,178958,547335,244838,12435,936769,686814,201594,316652,1000920,847131,306998,135770,115094,164386,1011275,275926,358,472436,907269,431988,799600,405885,40906,594270,826716,577498,1024781,1002,57180,1011149,1044326,971362,889036,854703,654100,697815,739438,16737,692526,983909,887319,295273,129120,594141,984774,614669,437741,284048,841618,608882,193812,3674,911726,38495,311973,654316,672836,413592) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]