SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543503 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543503 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (325828,543650,559645,488783,150948,912111,336448,442958,291610,201559,650212,426165,888373,50675,1040834,1034666,142992,167332,583114,206140,12681,888829,122636,880131,716856,588489,644481,981866,406919,548686,874795,326194,171536,361097,587062,592977,703365,348469,492033,576945,881292,531481,475111,501561,350204,5473,385556,368908,137048,718963,501198,691135,241619,132085,46360,420394,995594,74606,836357,750695) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002237s ]