SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200899 LIMIT 1 [ RunTime:0.001800s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200899 [ RunTime:0.005430s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111513,717460,235549,73454,1040815,892718,831685,517944,104892,5217,468464,661803,993730,569714,53201,1023773,32766,210741,393576,979187,47097,54456,1010086,74761,143580,353628,624391,82790,554953,548945,1010791,494524,125322,569238,489018,1004773,966686,737542,798784,1004540,951861,397548,32423,512737,895615,948614,269091,927826,763295,473154,127283,912938,734530,605586,431751,591309,59883,336227,737023,473823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200899 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200899 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]