SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 610502 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 610502 [ RunTime:0.002078s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617199,638383,923178,841482,867421,233442,820067,991891,122673,425039,665758,573115,401563,203755,603969,30832,442761,375725,914065,249656,660271,766959,916675,1008874,532023,368867,385049,590315,688596,649665,334939,762101,359863,19608,117231,144779,734349,65555,692697,775392,150772,813057,574902,112638,68138,669598,887893,494249,630416,1024966,117621,142631,928719,468995,466969,500050,332650,296590,1004001,280142) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 610502 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000634s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 610502 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000715s ]