SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459000 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459000 [ RunTime:0.001985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205760,824161,718011,270726,108777,405782,223943,81706,990402,937718,919098,102805,939030,154935,478534,491976,608907,1044552,135212,578531,374249,672748,28669,407219,154868,907626,111657,640649,816158,898270,11779,124354,932227,456360,1024194,916037,185499,162648,655509,621877,479667,574170,42112,468910,838699,536288,1029166,342926,861145,3193,11996,1041463,117977,853594,749454,173412,202328,1009799,616709,857252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001652s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459000 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459000 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]