SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010222 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010222 [ RunTime:0.002730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (837088,216011,174701,878989,898217,389260,254564,509261,886793,153154,234374,917519,235023,916669,768179,227803,613854,239435,244245,530867,1015896,494389,371210,381575,387517,607654,639975,751937,33954,824986,959759,335424,757334,227860,73330,733777,215840,234246,323883,121698,412647,836469,628215,675730,771373,674439,478249,272245,737165,573900,13061,526805,428774,290413,110773,621154,215281,728759,467248,147067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]