SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048431 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048431 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (604521,776030,541166,1009104,45750,341825,991564,250618,1005172,315354,187488,860150,763763,520573,787174,404666,727884,158368,298765,566947,648286,211601,985319,834432,867143,359981,581741,261627,696952,718280,960945,484137,607649,381326,571286,885599,423983,878251,114056,190711,3468,811340,543018,447614,361895,72299,719003,445119,3535,846873,187559,21422,451988,98954,1027642,146331,983863,477363,962092,385068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]