SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001512s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 762920 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 762920 [ RunTime:0.004207s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5233,540276,141015,760344,511688,555502,168341,509858,176633,260139,122964,185823,264847,243905,469844,424384,102171,705491,1039650,649021,302515,26985,591210,183659,608429,994545,144753,48698,556437,529404,806224,566972,559765,797211,577884,312546,834304,119758,384886,97636,683069,429180,344730,991495,230404,286637,927914,1036517,82645,298816,985432,347175,39782,54735,729355,1011554,877379,947624,415732,763299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 762920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 762920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]