SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 268216 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 268216 [ RunTime:0.001932s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748031,998836,237471,924021,851685,201681,700414,965112,977273,136457,53116,356398,353847,1011937,109428,129689,637085,134958,456948,552932,166169,428384,463153,1028811,1011691,989941,819993,547358,941644,940738,956871,413160,932975,166931,25280,470278,230717,458656,693124,113071,203874,1018712,174926,640577,1031209,354236,444755,1030713,989635,564612,592611,488688,946253,987296,645292,612184,423556,316939,794049,848460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 268216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 268216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000776s ]