SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002449s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104299 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104299 [ RunTime:0.001859s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (145482,1009659,513633,108900,264560,485807,210630,570068,233188,1027567,1004918,760154,584862,966985,900651,1012720,712692,29503,200990,536724,68831,566548,9859,872081,747405,491579,802643,622620,573606,742317,120406,570555,820938,627157,335741,582173,358533,65143,717138,338332,434838,929679,154390,415608,964073,370619,309749,110374,251537,588645,440233,326327,667673,699665,312012,213384,123301,514969,402107,743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104299 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104299 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]