SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001767s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 306293 LIMIT 1 [ RunTime:0.000981s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 306293 [ RunTime:0.002444s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006383,101299,148242,637440,688426,527277,659928,1929,805467,928761,406786,487745,412688,814205,298736,773721,491496,745079,472123,53547,174231,613596,248787,671397,81849,264215,292794,423283,577063,99165,38018,818591,613179,812165,451341,101796,14105,785052,433288,563152,45954,287205,641702,259281,1003416,181337,634407,210508,634319,661217,814276,983364,415920,125631,742635,500490,600472,627375,208570,60336) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 306293 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000796s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 306293 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]