SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543343 LIMIT 1 [ RunTime:0.000919s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543343 [ RunTime:0.003959s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (377294,519329,1022991,966145,37580,178875,959696,2645,680779,134135,556670,387426,914249,651057,653550,728784,846375,725564,34861,139878,17967,865930,52278,854337,654022,556439,38734,1032825,731595,891231,496436,326581,628144,608495,730047,925530,32453,166731,793467,96988,833452,248031,406109,702076,109424,89820,435632,10869,70418,970468,89787,487375,205494,628752,359744,646942,130704,147035,160476,345240) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]