SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570199 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570199 [ RunTime:0.002361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (325878,1029814,803676,778031,207996,1044772,865959,782522,15436,690982,285366,653399,204085,1017658,154218,355823,190695,63335,277866,871130,339357,375026,1012045,332635,476789,17990,911367,524376,155261,138078,408407,615117,525954,777975,823424,442004,304548,767722,453113,667432,826452,499564,321419,950234,1037266,911480,240458,1000269,666180,831226,749870,866337,825936,575112,442791,904187,257670,753024,294364,27834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.021211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001832s ]