SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803986 LIMIT 1 [ RunTime:0.002308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803986 [ RunTime:0.002998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (235918,1007218,78372,235484,1024367,392003,736947,996641,591764,420915,498213,729737,377842,306343,114684,5448,146343,881782,579022,796295,593069,5800,1021279,897411,1016091,732911,226609,368866,331885,610658,763245,270706,377401,1012640,82813,156585,939694,932924,842900,31920,1019091,864479,867632,632732,459925,990816,140181,327701,190024,309960,102736,320351,826717,1000311,550774,389959,179564,787940,392474,458211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]