SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015767 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015767 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50175,196270,804307,1015839,69962,345416,608839,980044,334026,100238,331378,804845,412687,532427,451026,764384,660860,26283,795833,794716,740358,807500,56198,797948,495700,251797,577502,396894,949785,271870,860244,765796,868184,83310,282723,88742,323274,784788,537724,735846,645933,163611,264295,360752,186465,869577,230773,906285,951380,687293,212818,515060,832673,953926,844264,937002,820824,790146,965096,472248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015767 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015767 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]