SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311460 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311460 [ RunTime:0.001974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (626260,634730,1014642,295947,653669,435911,581614,378442,884160,553788,979578,917209,635640,488531,708855,823339,88610,849924,1028069,343764,78288,665013,288052,442031,385922,954663,988232,182678,327630,599797,389242,727932,650973,900626,976193,846337,147367,895543,723840,792912,960805,193409,801609,705823,228766,17919,1015385,942617,215450,101886,933019,172497,423600,941761,114706,442796,200807,610198,14589,565384) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]