SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026456 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026456 [ RunTime:0.001529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (157365,562221,656567,301437,412083,381492,391567,77616,208564,832297,851799,670243,440075,909194,1041554,223602,966363,1012627,617760,650585,55992,409566,403368,118235,194676,799399,479295,896454,20418,343558,602561,113092,638675,160099,170002,624774,352621,179568,241051,522756,70269,728085,40464,353746,289686,159427,106932,675941,150876,734993,286546,628785,221343,575033,444543,171431,732153,324747,1033691,663203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026456 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026456 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]