SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506436 LIMIT 1 [ RunTime:0.001458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506436 [ RunTime:0.002869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642200,120036,355197,993613,599811,384105,258819,84265,625573,170043,358321,888282,54025,115262,341545,767118,280255,630656,601047,346906,186559,453767,326170,48406,518525,949139,126473,161857,728391,751980,885494,899659,716546,828790,851464,186740,89256,288749,902011,262576,262090,562282,44940,140046,1000900,782583,116506,495583,1006257,1021480,582590,100416,735312,355352,458079,58352,800313,236490,188999,205141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.020631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506436 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506436 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001446s ]