SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415203 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415203 [ RunTime:0.002224s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (163657,420897,196850,715503,388868,885020,965147,594400,398664,649427,915475,168486,191055,155333,42753,131419,555080,17170,471926,991973,396573,615568,655705,676606,151104,240507,967728,462743,542453,719905,714709,926677,919750,872394,377242,611414,227299,114421,242052,101141,454236,809922,125365,1048694,256174,227191,28400,234939,128470,225142,788691,521876,785584,1039632,892361,738333,179999,773599,254573,193713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000727s ]