SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48136 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48136 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295911,267621,37328,161088,264330,180452,887750,755025,181353,782447,370143,527842,368571,96774,987442,119011,12973,563177,492849,580373,256744,791550,304960,155920,82574,1024950,71535,127914,125379,962019,337364,976591,557311,1005113,908784,901964,330558,391457,751344,506613,560015,332333,486021,588817,625283,513363,857909,408990,505258,689097,966683,825702,595065,31557,154820,684380,369722,841634,862606,953016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48136 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48136 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002933s ]