SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280138 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280138 [ RunTime:0.001981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415317,443329,674720,1027722,155120,113888,294444,619971,5588,41109,806214,984305,853444,921718,272907,626525,126704,497953,600772,539177,524475,1020548,80196,662860,327718,357043,176536,563324,1032308,452212,998483,444484,875551,14142,735670,392561,784014,504554,825216,529310,508613,427900,222058,560891,428542,53095,496289,728223,880734,121873,296432,728914,322008,10534,702309,1020314,515616,636162,996041,159658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]