SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001820s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549323 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549323 [ RunTime:0.001890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677027,240521,486604,71255,24646,619068,931320,309364,577131,1004497,1022396,314402,459660,356801,103595,202948,279008,290557,527596,543798,474999,205540,285367,646338,537394,779139,972762,741142,522574,379026,1028446,437620,50699,552301,651738,31211,1019658,873768,300042,73300,162543,744649,26738,361439,452508,383085,200819,642329,203316,318632,190653,776985,461083,61536,317974,502003,381906,116383,356752,382130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]