SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001989s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 55803 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 55803 [ RunTime:0.001583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (656318,58369,477311,986469,668440,23446,411829,716610,170624,784872,21342,100039,36486,239479,500274,900680,151786,62689,92833,132200,884968,817506,617862,594420,721299,502355,652375,363175,545752,407744,196435,130098,770824,290574,490509,39963,315372,1013769,673367,357604,1019989,1025129,171853,433123,518521,892673,1047274,1023386,109835,597796,443529,520540,431428,579527,312688,1030347,172896,982561,807618,932734) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001869s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 55803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 55803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]