SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533413 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533413 [ RunTime:0.004695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (84979,870416,727874,584334,464568,600661,50002,980604,177012,484053,901952,49829,122002,197431,424874,995445,253556,826614,124778,218776,87342,895241,156323,11457,322708,419563,365983,210706,319397,246597,999841,250456,491221,360922,853003,429545,271196,135482,326441,316147,670255,443401,799512,820087,853795,365977,887635,822198,825938,385634,143793,249827,518166,337130,959007,789830,735987,595078,85392,869286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]