SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532735 LIMIT 1 [ RunTime:0.000718s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532735 [ RunTime:0.002344s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (931262,771847,70623,320457,905931,563971,220305,961206,939238,901354,535896,864029,558366,456576,417342,935600,683348,656032,950209,753428,275961,944345,929599,1047040,25262,808923,324703,721030,202903,73267,256474,133214,1003827,246381,714568,331596,556964,420792,440078,962755,787118,851927,917975,139982,949000,867265,487816,992510,507235,448349,753612,648687,622776,836658,133392,783094,119930,521908,269178,217400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532735 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532735 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001906s ]