SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291580 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291580 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (663207,298639,897760,1030866,667000,346994,624564,853063,1033098,56228,764128,172843,779688,329492,625912,957936,1014260,156351,1008859,16126,421280,99984,494427,46822,357899,888647,687650,237973,948030,832603,624356,599990,213239,230292,338014,79805,700314,959495,633644,544070,956521,777583,126966,727365,402521,212845,59198,175776,877037,241813,650037,234455,355306,470616,300709,962203,623526,225428,826370,465201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]