SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001457s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 387181 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 387181 [ RunTime:0.002583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201485,511221,194720,773249,331259,390907,373250,935603,805013,341573,181655,668741,709826,630101,959416,990273,404643,186434,747791,389565,895237,1044889,562547,95646,185016,426850,485213,743161,824780,775470,764179,228428,504343,873771,124818,693068,532620,361205,94753,422536,375794,597562,1026026,824169,162731,891489,581962,987103,506614,257320,844973,452821,1022593,898924,721545,136405,181435,718815,324080,216355) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 387181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 387181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]