SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001599s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402590 LIMIT 1 [ RunTime:0.001812s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402590 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111501,781462,587957,91043,86356,334643,94962,626536,178755,579642,88781,444774,362608,129976,525836,633330,863700,614422,187807,754425,114375,270845,515004,280127,11916,568228,44260,584132,646886,349408,373237,10382,641197,689597,654348,467586,439723,140550,290119,37000,1019163,211927,940551,844742,694670,916351,972613,267438,805569,198695,883077,82967,71703,1031803,852511,7408,148696,319,394958,662710) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402590 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402590 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]