SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535258 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535258 [ RunTime:0.002663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (148926,540915,135962,1010500,632834,252902,348450,689889,380605,340761,566373,687629,75225,478038,99514,29808,541631,21178,719182,252759,426358,22435,60165,479456,871002,318077,48702,917490,271335,923862,343496,386163,767576,930835,895339,950361,786402,332602,257459,579182,498756,172607,312332,995526,76989,894331,264931,475090,955616,764693,225559,118801,1046100,821269,66571,697306,516928,414954,347447,914744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535258 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535258 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]