SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591021 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591021 [ RunTime:0.002485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (757520,584822,721847,222755,839819,359638,501242,202263,236418,599962,548551,809176,552288,991529,847367,494814,866726,369354,16392,188571,232249,351655,714266,1018876,774260,506013,497684,858327,691248,897914,942287,487347,349317,30306,608318,551106,422536,770827,124580,828761,374609,438149,571153,493995,152187,577685,393530,38340,883834,180917,884311,942004,281065,27803,906607,106381,559622,831816,95193,99873) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]