SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021561 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021561 [ RunTime:0.003048s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286268,427503,164913,731668,816400,1023313,1048280,255843,549937,363209,407101,150227,933043,942531,815909,21419,101833,913327,991152,381929,993892,619152,734709,870503,235692,52930,217728,452609,306196,113801,3268,264984,803431,423511,633202,464832,624034,1030600,158654,595701,679828,572296,731793,642354,522707,476523,472870,953203,383,134797,7166,854287,203406,216903,518109,907080,653363,272906,968441,583030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021561 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021561 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002914s ]