SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802943 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802943 [ RunTime:0.003570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362032,724214,410800,904656,362577,885055,339528,707044,186897,957481,45772,345839,305295,476703,456409,219320,438813,763447,736153,75747,859140,384341,855209,635341,475353,1000959,665775,969912,782614,380720,831753,331070,856872,170961,514791,88175,857294,1013534,58512,388093,269407,543682,751439,226928,485123,660576,43557,683351,584681,1040898,241391,711000,650335,913874,137471,831259,669572,573068,296266,685201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]