SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402210 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402210 [ RunTime:0.001873s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393659,549011,5797,198439,291165,779658,521400,669373,412934,720559,67170,456197,760164,917661,33632,17473,385303,158707,102433,531577,927843,567937,753166,672340,694599,988583,263047,136411,482372,403109,617251,789352,373726,260427,61718,118891,923908,263015,613189,520873,124590,85688,305314,494468,164396,104007,857411,785269,1010560,289971,937951,76021,748513,980451,668095,844593,544543,475885,427948,174412) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]