SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444841 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444841 [ RunTime:0.001958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259310,61459,719558,416528,499648,556518,962146,547096,342605,143740,942829,879384,26494,958191,727423,671372,57053,370524,1022853,625384,751139,281040,300524,907083,173207,965693,725759,928955,255058,511796,506129,144918,113091,301917,132045,161318,549867,160616,935420,641537,449482,786108,538748,984172,941680,1017533,894892,793134,105214,520825,632794,427094,937144,192932,1038731,347393,881844,744343,178066,931640) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003296s ]