SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510008 LIMIT 1 [ RunTime:0.001856s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510008 [ RunTime:0.001928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391895,483518,817194,938866,67399,44986,678147,987411,594173,422864,504848,108054,320770,448180,414106,743010,787515,301433,498327,3520,867840,248145,230781,34360,595460,203421,472084,1044426,270829,231418,122815,581168,209813,70888,224869,789564,140438,671526,413587,233690,819869,271470,772404,492563,295026,799607,576749,45653,67536,838651,969142,79034,51410,727109,313244,70707,146214,649837,369005,101699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]