SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 143043 LIMIT 1 [ RunTime:0.001427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 143043 [ RunTime:0.004237s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537819,266672,414004,401585,181956,765703,481511,583457,693203,355966,939579,191838,307381,82168,411161,743978,768300,1040920,79044,266332,380349,305048,212221,566150,812443,626570,690151,94989,592312,142792,350374,670198,214762,80412,512376,877541,818317,566848,662222,937872,683606,47504,808253,995827,264116,228644,483961,444640,1040278,354454,655552,960677,579354,183261,920819,974597,189912,111042,805549,781187) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001695s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 143043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 143043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]