SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40710 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40710 [ RunTime:0.001929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267552,220545,408094,717181,799005,879371,377801,617692,1007507,295944,834221,108378,725784,105034,790937,13932,136742,2717,417963,563945,61320,370999,771826,374532,368402,657974,138394,437760,683572,833938,940907,305603,882525,803219,849911,453128,571460,491581,210775,775394,418885,262894,580050,739854,609436,197487,264003,46734,651081,573080,677754,428330,591750,782608,923817,109922,802979,9793,769130,996962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]