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` = 398985 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398985 [ RunTime:0.003496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507929,428665,1000285,226760,932589,522715,1009201,213358,298274,869388,472834,198599,466800,172298,82713,150692,170106,498909,855417,871009,422533,88759,706319,411667,924568,569327,991020,523976,450693,340855,346815,884640,479367,576285,442688,870944,415668,1025627,4604,211250,611058,717370,997415,445687,797669,4007,139569,754897,965664,622777,887521,9632,1027191,399665,386445,604910,221208,695041,12819,407829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]