SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416822 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416822 [ RunTime:0.001520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300044,234517,107684,489050,458272,771862,78360,766828,442139,291337,142605,130201,292948,446357,500464,180620,941444,142228,165513,758162,167504,570789,517362,965663,30921,87536,1006475,32909,551924,838662,893773,252945,207914,705333,505638,384768,348339,460441,894467,764016,71480,229550,220905,431426,300033,379150,493223,25056,568637,100150,742147,810470,878476,611154,21614,728229,543353,351660,891223,414453) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]