SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002973s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511398 LIMIT 1 [ RunTime:0.001339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511398 [ RunTime:0.004102s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269846,912702,274467,803466,27541,617481,570151,681108,535442,981569,621177,522673,500062,285028,597650,298258,618764,719748,183855,462008,591250,606397,957408,1017985,382065,224165,951919,84718,615572,640078,787593,868687,1010206,222839,13472,199128,881973,856620,550302,910401,612533,742578,728667,625047,707367,807021,79799,1046069,267636,403931,73004,1042699,398037,172408,351594,939144,404884,161177,342777,864327) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]