SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110601 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110601 [ RunTime:0.002300s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (491894,296590,564178,591774,861205,765962,357781,901810,45889,452404,317091,38657,72238,43067,939698,498091,261752,666678,593822,1040410,364435,98239,754699,444581,459329,996229,163987,955945,203073,176258,575227,47642,281880,402054,650650,1010291,500971,804678,709560,1013656,788726,23121,822138,9490,170828,290894,75205,596118,419241,1030944,460046,759989,817881,560910,608888,814034,528837,584520,334853,976773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]