SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533312 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533312 [ RunTime:0.003484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (271963,951127,185260,197273,880753,587582,994381,713793,625168,686857,273359,908972,569628,207804,459691,837196,223020,717700,992764,48192,233288,613873,746995,604794,503878,55760,81418,296471,966856,659038,256712,833113,255045,516997,288448,1017690,145393,812700,252282,124424,432802,974392,6782,17087,752978,28224,760805,973740,547511,262615,549955,395164,350737,744336,247275,529906,4450,1040962,603915,577478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000759s ]