SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531036 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531036 [ RunTime:0.002088s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287466,550166,143079,1022768,792712,145373,965856,249304,497971,1012275,20523,713731,636365,12613,813338,29844,654661,423328,1026474,574265,792073,105404,995931,436518,62623,168857,981377,909735,30398,793878,707655,1030790,695259,930045,159287,301075,886150,162736,764139,1019419,119151,578454,793169,999219,152808,597106,510030,737035,447701,110439,620739,920350,367253,305041,407427,344929,204588,256684,1048690,1035597) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000791s ]