SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110006 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110006 [ RunTime:0.001259s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18928,776816,752552,183599,160427,936782,852161,394887,872189,692441,300479,386705,856278,175686,786121,816132,430630,284771,139923,912682,934818,648858,1017635,921153,172189,917325,153532,353478,424969,108506,503543,736159,586158,775930,563216,883591,28161,831531,615788,463450,543242,46584,213618,202167,375548,706155,298996,780343,956441,549540,46478,713575,587782,1036164,932447,583120,1012951,533248,330530,603381) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]