SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002082s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 670309 LIMIT 1 [ RunTime:0.000697s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 670309 [ RunTime:0.007882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121967,111314,952585,507421,1032160,23438,302545,27848,184254,176014,338056,57631,90840,387431,27739,78612,232376,125245,949111,446224,26165,548207,1006773,674038,134924,953976,931050,1016529,308718,802899,637910,910383,962454,894187,810589,858051,235249,229095,650139,465307,300649,937151,966089,909003,737662,681711,288776,998586,746433,133876,141993,1044982,671639,219186,268082,899227,596399,624331,525345,264723) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 670309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 670309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006232s ]