SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442003 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442003 [ RunTime:0.002296s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (951191,662743,974019,39613,430373,471202,1024694,255406,823366,914624,433398,626688,430919,761632,655962,521352,434639,611313,345283,265575,47512,939918,569234,774387,237348,195894,492300,376765,599403,197202,207713,684135,59758,508658,357625,144450,664089,726620,827516,506166,976933,853183,486510,153695,753298,227623,1048681,555271,789243,321090,190725,860668,352625,725542,243289,672764,581089,947817,84553,914115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001711s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002736s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]