SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508497 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508497 [ RunTime:0.003553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (795789,124301,280179,249326,946193,154192,976831,623536,54088,630945,926626,145617,304181,626488,244994,951754,975492,844849,852866,1001577,995348,932005,177336,116933,401018,977749,591420,59901,615281,171610,633876,135974,888152,591217,758544,718847,965799,884214,460594,407533,637577,509054,989740,852262,15472,373836,128908,245933,668195,396637,60808,992281,967879,599879,970853,723756,475022,776454,22190,531895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508497 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508497 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]