SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 211009 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 211009 [ RunTime:0.002493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410225,342747,182030,195494,861091,567668,932079,866966,272014,376091,716080,1042010,483009,893309,991121,978856,112902,669930,1005199,130454,1000046,885679,855769,654288,483252,1023778,203764,172324,508682,832901,302096,672609,854916,113469,484425,151679,702093,815950,477413,994104,730427,809602,264831,1015919,653129,105767,725857,35239,898346,742090,970297,136694,430776,403043,238146,1025318,84675,699500,514272,468642) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 211009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 211009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]