SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 55028 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 55028 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245092,146535,629447,763234,979499,197560,283550,548758,635725,377773,258928,975128,144203,915912,736871,504072,418217,402579,373760,434061,1047545,1032345,118886,745405,749099,304595,72235,81770,729573,542453,535600,683389,648295,710382,604781,199669,890386,297331,230231,43663,242302,328420,197141,712137,236646,116044,467615,371587,952482,257732,624512,2276,489738,167616,9282,931905,711298,747920,547892,381859) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 55028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 55028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]