SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 664903 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 664903 [ RunTime:0.002034s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455042,241361,688338,501429,581062,612862,600223,164877,550376,885985,591591,867161,237737,551942,431626,569754,218777,744442,33441,231614,494260,405386,39027,586030,167596,656815,431017,444201,514861,450269,914042,824436,847995,7079,79142,143483,415536,415974,446848,348329,442323,816596,456741,132016,649991,792578,127719,1017649,608984,976527,543787,850037,420880,1040322,642377,13741,535363,184072,561007,213649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 664903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 664903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]