SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681403 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681403 [ RunTime:0.002608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (637798,243788,1039890,142200,707879,725203,695349,937469,1014414,448415,495720,282933,858102,406367,747980,86513,402223,48292,521499,141120,351142,532664,226555,402662,188911,798082,760070,96709,902732,549135,653927,872837,52886,624177,697641,394720,999409,99228,58319,164373,960743,727479,95425,599541,753148,331670,98747,650016,162477,235837,201462,238628,961454,694688,549417,402889,825362,69410,670308,728625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]