SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 648218 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 648218 [ RunTime:0.001535s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (658529,538769,870427,890110,479909,188335,241051,358559,364318,638167,409319,34220,159515,276380,945138,553149,40233,80309,236069,142641,1045707,819819,781128,902524,559122,835414,808615,48014,198139,40705,166061,806389,833650,255207,340824,708965,198313,550335,444005,1025554,658013,178464,687351,655603,997685,458900,510225,553965,409599,1038626,324588,683962,928078,903453,534682,518831,736945,82745,561935,495192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 648218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 648218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000393s ]