SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501843 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501843 [ RunTime:0.001434s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (785147,630479,421876,712970,779981,1007788,1020129,567272,26013,299815,343252,692504,712516,981217,997375,839876,919324,131483,538393,70197,495507,140229,575587,453405,738681,44158,763069,990446,347480,147016,519375,748605,475979,678847,385000,816670,901242,267172,224878,136891,723258,69023,538744,816151,328232,541296,341977,679430,59740,508210,722754,533136,184482,718619,95296,1019030,914675,19030,241290,656391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]