SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42656 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42656 [ RunTime:0.001520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (397249,403469,531377,966924,625036,50599,1016033,504060,603007,506439,98563,707193,553776,724451,150588,932391,901541,631556,62727,756860,990611,477540,349891,1012691,320200,20756,446417,928866,67992,572243,64320,37397,533889,818208,49604,735830,684431,455004,136155,955974,368840,446509,455984,393999,183667,180358,708513,236961,369702,445415,150279,892508,240359,461332,552301,40332,683573,273963,990769,685560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42656 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42656 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]