SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031048 LIMIT 1 [ RunTime:0.003438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031048 [ RunTime:0.002642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523400,1032453,590822,366254,56019,956896,579869,608053,983523,159962,815671,501069,274621,937636,479366,806952,286179,442608,1001902,423465,76524,825928,268338,1002807,125255,970003,442061,501552,809413,383704,668402,15125,486014,510208,184245,502686,253533,560734,841077,738072,592531,3239,401204,868504,138788,695269,341138,352905,419114,586225,127281,632667,464004,227506,782670,849228,547797,826849,994600,7306) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001895s ]