SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001870s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410392 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410392 [ RunTime:0.001937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642611,306789,349110,58532,1038722,114502,616359,794728,921246,716866,1250,162196,884005,881975,364925,548593,117386,59489,139277,934011,116146,369704,349558,54943,860979,634026,229259,861068,323300,119668,511676,955720,493927,552408,223660,718193,201843,247426,618340,234090,872158,438248,876542,825977,805934,749393,734115,221867,497546,554850,165842,853802,410562,989580,586232,826813,319830,858422,969812,556457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410392 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410392 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]