SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 265097 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 265097 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (349656,188708,29001,725890,489364,327348,289360,271014,140347,16578,856985,828271,556986,631296,55168,400798,1022245,1048354,264973,120412,394668,731043,439234,898358,352469,590272,607421,550201,90955,1005000,671960,383385,899778,822486,96539,1042742,919202,391014,1044872,133672,1015398,280795,595636,78443,441144,689127,832031,957682,510218,1046952,335429,338147,831739,321456,64713,250328,1011436,826092,14884,396751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 265097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 265097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]