SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 920441 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 920441 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (35788,628893,328869,798416,441257,822747,318703,261592,717834,908724,322216,293720,308192,910988,341422,360740,855303,1005268,710538,603391,789425,475918,285588,221838,992873,389921,242599,70311,32495,180178,482151,744609,476901,656813,194452,471454,721542,206115,194424,502893,380648,247713,346031,705381,1018030,223018,508351,167639,392883,446781,677343,1009396,78630,935370,133444,674989,283060,410344,706699,69761) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 920441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 920441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]