SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280489 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280489 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545307,979501,614680,177402,153367,629988,698569,290024,525825,560035,707168,294710,225919,978459,782999,411318,831,124910,1028223,882546,82447,596157,276691,969125,593225,122317,618131,586347,651210,364104,78826,337107,516882,545538,788851,147034,473732,8898,499011,40828,728109,623879,1017374,909712,626934,153984,195227,229041,285135,19219,695468,597257,244037,66969,459737,414992,948097,180416,851050,968873) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280489 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280489 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001431s ]