SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 664313 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 664313 [ RunTime:0.001953s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (772024,689320,1000752,516657,80465,362005,500964,641947,103363,914931,260507,854265,761466,718831,527160,996543,508664,227218,967148,654088,922351,270251,828844,781060,520512,208272,857986,87565,16481,148622,996852,302580,239758,572080,451706,479724,815791,340344,95332,345653,923052,814632,682531,413755,291372,815414,42373,649360,106865,152317,124675,967773,689909,627313,675434,628095,351018,1030754,793734,420013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 664313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 664313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]