SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001629 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001629 [ RunTime:0.001662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130591,397942,466856,486285,450843,956848,216051,440821,876051,224900,582945,929127,16283,52017,611002,591467,61559,36844,457820,135982,181002,524097,790890,893141,267392,513964,1028461,361837,768618,20524,859662,263051,979200,468624,601322,319841,736776,383886,81696,853879,188360,946475,1027469,479344,576408,606225,855519,824189,288850,96543,398388,794779,546305,972971,662400,401371,617549,1019177,755344,364080) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001629 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001629 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000396s ]