SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346608 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346608 [ RunTime:0.002068s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (852607,571110,766789,615135,20908,545097,87123,106079,842435,449794,230745,141813,179966,212849,274868,738973,982061,306655,403435,845721,309141,549847,72323,178704,783401,832936,3168,477129,176084,846526,1033577,557429,539163,302512,702576,502416,1037785,343146,731454,571793,1044500,447460,729897,299621,213351,95726,865914,22311,5485,734772,830715,63513,601310,478326,59426,606560,670217,512483,1008716,920277) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]