SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037405 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037405 [ RunTime:0.001913s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527880,42595,260081,989938,964219,662165,195801,299012,776758,915709,269015,541086,490768,169995,553656,254799,604216,231786,614915,600245,834161,900365,544867,568883,611575,983684,12800,966882,918591,522588,901192,525341,784070,765441,668883,20907,85983,145380,356116,1046024,203663,867389,100780,263556,885052,606604,328554,40713,513331,215353,71845,23075,44012,576090,742330,372159,518835,896415,542092,845922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]