SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566083 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566083 [ RunTime:0.002152s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (881623,975225,84029,563659,763097,728845,219872,564555,121832,389846,996755,474130,1016386,144809,581104,487234,942338,195848,962518,190358,208707,551123,69943,833250,817213,624324,725162,400845,168128,1034576,621206,1042333,186397,154360,279539,955492,357953,1006658,1004740,205526,424975,815448,211974,266859,32624,906635,278164,756626,440969,208922,459726,1020377,825152,946767,907509,437750,585808,750973,1042454,565040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000376s ]